
import pyodbc
import pandas as pd
import numpy as np
from matplotlib import pyplot as plt
from IPython.display import display
import plotly.graph_objects as go
import numpy as np
import sqlalchemy as sa
import warnings

warnings.filterwarnings('ignore')

pd.options.display.max_rows = None
pd.options.display.max_columns = None

try:
    server  = 'DESKTOP-7AVUQ5G'
    database = 'practical_sql'
    trusted_connection = 'yes'
    driver = 'SQL Server'
    pd.set_option('display.max_columns', None)
    conn = pyodbc.connect(f'Driver={driver};'
                        f'Server={server};'
                        f'Database={database};'
                        f'Trusted_Connection={trusted_connection};')

    cursor = conn.cursor()
    print("Everything is working as expected")

except:
    print("Oops, something went wrong!")

Everything is working as expected


pd.options.display.max_rows = None
pd.options.display.max_columns = None
query = """
SELECT *
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]

  
 

"""
df = pd.read_sql_query(query, conn)


df


query = """
SELECt age, gender2,count(*) as amount
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]
  group by age,gender2
  order by count(*) desc


  
 

"""
df = pd.read_sql_query(query, conn)


df


import plotly.express as px

gender= df['gender2']
age=df['age']



fig = px.pie(values=age, names=gender)
fig.update_layout(
    title=dict(text="Shipman's prefered victims were Women"), font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()


query = """
SELECT yearofDeath,count(yearofDeath) as number
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]
  group by yearofDeath



  
 

"""
df = pd.read_sql_query(query, conn)
df


import numpy
import plotly.express as px



# Random Data
names = df['yearofDeath']
x =   df['number']

fig = px.pie(values=x, names=names)
fig.update_layout(
    title=dict(text="Years when Shipman killed most of his victims."),font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()


query = """
SELECT placeofdeath, count(placeofdeath) as [amount of deaths]
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]
  group by PlaceofDeath
  order by count(placeofdeath) desc


  
 

"""
df = pd.read_sql_query(query, conn)
df


import numpy
import plotly.express as px


# Random Data
names = df['placeofdeath']
x = df['amount of deaths']

fig = px.pie(values=x, names=names)
fig.update_layout(
    title=dict(text="Shipman killed most of his victims in their own home."), font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()


query = """
SELECt age, gender2,count(*) as amount
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]
  group by age,gender2
  order by count(*) desc



  
 

"""
df = pd.read_sql_query(query, conn)
df


import plotly.express as px

age, gender = df["age"],df["gender2"]


 
fig = px.box(y = age, x=gender, points="all")
fig.update_layout(
    title=dict(text="Shipman's preferred victims were old old people"),font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightpink",plot_bgcolor = "rgba(0,0,0,0)")
fig.update_layout(

    xaxis_title="Months",
    yaxis_title="Years ",
    legend_title="Legend Title"
)



fig.show()


query = """
SELECT YEAR([DateofDeath]) AS Year,
	   FORMAT([DateofDeath], 'MMMM') AS Month,
	   day([DateofDeath]) AS Day,
	   *         

 from [dbo].[shipman_confirmed_victims]
 


  
 

"""
df = pd.read_sql_query(query, conn)
df


month=df["Month"]
year = df["Year"]
fig = px.box(x=month, y=year)
fig.update_layout(title=dict(text="Shipman's killings per months in a spam or more than 3 decades"), font=dict(size=15))
fig.update_layout(paper_bgcolor="lightpink", plot_bgcolor="rgba(0,0,0,0)")


fig.update_layout(
   
    xaxis_title="Months",
    yaxis_title="Years ",
    legend_title="Legend Title"
    )






fig.show()


cursor = conn.cursor()
cursor.close()
print("Connection has been closed!!")

Connection has been closed!!

	age	gender2	amount
0	84	Women	12
1	74	Women	11
2	81	Women	11
3	76	Women	9
4	77	Women	8
5	79	Women	8
6	73	Women	8
7	82	Women	8
8	75	Women	7
9	69	Women	7
10	70	Women	7
11	80	Women	7
12	78	Women	6
13	83	Women	6
14	85	Women	5
15	86	Women	5
16	87	Women	5
17	88	Women	5
18	71	Women	4
19	72	Women	4
20	68	Women	4
21	77	Men	4
22	85	Men	4
23	63	Women	4
24	67	Women	3
25	88	Men	3
26	82	Men	3
27	90	Women	3
28	89	Women	2
29	83	Men	2
30	73	Men	2
31	76	Men	2
32	81	Men	2
33	90	Men	2
34	51	Women	2
35	53	Women	2
36	54	Women	2
37	65	Women	2
38	57	Women	2
39	58	Women	1
40	59	Women	1
41	60	Women	1
42	64	Women	1
43	56	Women	1
44	47	Women	1
45	49	Women	1
46	75	Men	1
47	86	Men	1
48	87	Men	1
49	78	Men	1
50	79	Men	1
51	80	Men	1
52	41	Men	1
53	43	Men	1
54	47	Men	1
55	67	Men	1
56	69	Men	1
57	70	Men	1
58	72	Men	1
59	92	Women	1
60	93	Women	1

	yearofDeath	number
0	1975	1
1	1978	4
2	1979	2
3	1981	2
4	1983	2
5	1984	9
6	1985	11
7	1986	8
8	1987	8
9	1988	11
10	1989	12
11	1990	2
12	1992	1
13	1993	16
14	1994	11
15	1995	30
16	1996	30
17	1997	37
18	1998	18

	placeofdeath	amount of deaths
0	Own home	204
1	Shipman's surgery	6
2	Residential Home	2
3	Hospital	2
4	Nursing home	1

	age	gender2	amount
0	84	Women	12
1	74	Women	11
2	81	Women	11
3	76	Women	9
4	77	Women	8
5	79	Women	8
6	73	Women	8
7	82	Women	8
8	75	Women	7
9	69	Women	7
10	70	Women	7
11	80	Women	7
12	78	Women	6
13	83	Women	6
14	85	Women	5
15	86	Women	5
16	87	Women	5
17	88	Women	5
18	71	Women	4
19	72	Women	4
20	68	Women	4
21	77	Men	4
22	85	Men	4
23	63	Women	4
24	67	Women	3
25	88	Men	3
26	82	Men	3
27	90	Women	3
28	89	Women	2
29	83	Men	2
30	73	Men	2
31	76	Men	2
32	81	Men	2
33	90	Men	2
34	51	Women	2
35	53	Women	2
36	54	Women	2
37	65	Women	2
38	57	Women	2
39	58	Women	1
40	59	Women	1
41	60	Women	1
42	64	Women	1
43	56	Women	1
44	47	Women	1
45	49	Women	1
46	75	Men	1
47	86	Men	1
48	87	Men	1
49	78	Men	1
50	79	Men	1
51	80	Men	1
52	41	Men	1
53	43	Men	1
54	47	Men	1
55	67	Men	1
56	69	Men	1
57	70	Men	1
58	72	Men	1
59	92	Women	1
60	93	Women	1

	DateofDeath	Name	Age	PlaceofDeath	Decision	yearOfDeath	gender	fractionalDeathYear	ageBracket	gender2
0	1975-03-17	Eva Lyons	70	Own home	Unlawful killing	1975	False	1974.709961	70-74	Women
1	1978-08-07	Sarah Hannah Marsland	86	Own home	Unlawful killing	1978	False	1978.099976	85-89	Women
2	1978-08-30	Mary Ellen Jordan	73	Own home	Unlawful killing	1978	False	1978.160034	70-74	Women
3	1978-12-07	Harold Bramwell	73	Own home	Unlawful killing	1978	True	1978.439941	70-74	Men
4	1978-12-20	Annie Campbell	88	Own home	Unlawful killing	1978	False	1978.469971	85-89	Women
5	1979-08-10	Alice Maude Gorton	76	Own home	Unlawful killing	1979	False	1979.109985	75-79	Women
6	1979-11-28	Jack Leslie Shelmerdine	77	Hospital	Unlawful killing	1979	True	1979.410034	75-79	Men
7	1981-04-18	May Slater	84	Own home	Unlawful killing	1981	False	1980.800049	80-84	Women
8	1981-08-26	Elizabeth Ashworth	81	Own home	Unlawful killing	1981	False	1981.150024	80-84	Women
9	1983-01-04	Percy Ward	90	Own home	Unlawful killing	1983	True	1982.510010	90-94	Men
10	1983-06-28	Moira Ashton Fox	77	Own home	Unlawful killing	1983	False	1982.989990	75-79	Women
11	1984-01-07	Dorothy Tucker	51	Own home	Unlawful killing	1984	False	1983.520020	50-54	Women
12	1984-02-08	Gladys Roberts	78	Own home	Unlawful killing	1984	False	1983.609985	75-79	Women
13	1984-04-15	Joseph Bardsley	83	Own home	Unlawful killing	1984	True	1983.790039	80-84	Men
14	1984-04-24	Winifred Arrowsmith	70	Own home	Unlawful killing	1984	False	1983.810059	70-74	Women
15	1984-09-21	Mary Winterbottom	76	Own home	Unlawful killing	1984	False	1984.219971	75-79	Women
16	1984-11-27	Ada Ashworth	87	Own home	Unlawful killing	1984	False	1984.410034	85-89	Women
17	1984-12-17	Joseph Vincent Everall	80	Own home	Unlawful killing	1984	True	1984.459961	80-84	Men
18	1984-12-18	Edith Wibberley	76	Own home	Unlawful killing	1984	False	1984.469971	75-79	Women
19	1984-12-24	Eileen Theresa Cox	72	Own home	Unlawful killing	1984	False	1984.479980	70-74	Women
20	1985-01-02	Peter Lewis	41	Own home	Unlawful killing	1985	True	1984.510010	40-44	Men
21	1985-02-01	May Brookes	74	Own home	Unlawful killing	1985	False	1984.589966	70-74	Women
22	1985-02-04	Ellen Higson	84	Own home	Unlawful killing	1985	False	1984.599976	80-84	Women
23	1985-02-15	Margaret Ann Conway	69	Own home	Unlawful killing	1985	False	1984.630005	65-69	Women
24	1985-02-22	Kathleen McDonald	73	Own home	Unlawful killing	1985	False	1984.650024	70-74	Women
25	1985-06-26	Thomas Moult	70	Own home	Unlawful killing	1985	True	1984.989990	70-74	Men
26	1985-06-26	Mildred Robinson	84	Own home	Unlawful killing	1985	False	1984.989990	80-84	Women
27	1985-08-23	Frances Elizabeth Turner	85	Own home	Unlawful killing	1985	False	1985.150024	85-89	Women
28	1985-12-17	Selina Mackenzie	77	Own home	Unlawful killing	1985	False	1985.459961	75-79	Women
29	1985-12-20	Vera Bramwell	79	Own home	Unlawful killing	1985	False	1985.469971	75-79	Women
30	1985-12-31	Fred Kellett	79	Own home	Unlawful killing	1985	True	1985.500000	75-79	Men
31	1986-01-07	Deborah Middleton	81	Own home	Unlawful killing	1986	False	1985.520020	80-84	Women
32	1986-04-23	Dorothy Fletcher	74	Residential Home	Unlawful killing	1986	False	1985.810059	70-74	Women
33	1986-06-06	Thomas Fowden	81	Own home	Unlawful killing	1986	True	1985.930054	80-84	Men
34	1986-09-15	Mona Ashton White	63	Own home	Unlawful killing	1986	False	1986.209961	60-64	Women
35	1986-10-07	Mary Tomlin	73	Own home	Unlawful killing	1986	False	1986.270020	70-74	Women
36	1986-11-17	Beatrice Toft	59	Own home	Unlawful killing	1986	False	1986.380005	55-59	Women
37	1986-12-16	Lily Broadbent	75	Own home	Unlawful killing	1986	False	1986.459961	75-79	Women
38	1986-12-23	James Wood	82	Own home	Unlawful killing	1986	True	1986.479980	80-84	Men
39	1987-03-30	Frank Halliday	76	Own home	Unlawful killing	1987	True	1986.750000	75-79	Men
40	1987-04-01	Albert Cheetham	85	Own home	Unlawful killing	1987	True	1986.750000	85-89	Men
41	1987-04-16	Alice Thomas	83	Own home	Unlawful killing	1987	False	1986.790039	80-84	Women
42	1987-05-08	Jane Frances Rostron	78	Own home	Unlawful killing	1987	False	1986.849976	75-79	Women
43	1987-09-14	Nancy Anne Brassington	71	Own home	Unlawful killing	1987	False	1987.209961	70-74	Women
44	1987-12-11	Margaret Townsend	80	Own home	Unlawful killing	1987	False	1987.449951	80-84	Women
45	1987-12-29	Nellie Bardsley	69	Own home	Unlawful killing	1987	False	1987.500000	65-69	Women
46	1987-12-30	Elizabeth Ann Rogers	74	Own home	Unlawful killing	1987	False	1987.500000	70-74	Women
47	1988-01-05	Elizabeth Fletcher	90	Own home	Unlawful killing	1988	False	1987.510010	90-94	Women
48	1988-01-15	Alice Mary Jones	83	Own home	Unlawful killing	1988	False	1987.540039	80-84	Women
49	1988-02-09	Dorothea Hill Renwick	90	Own home	Unlawful killing	1988	False	1987.609985	90-94	Women
50	1988-02-15	Ann Cooper	93	Own home	Unlawful killing	1988	False	1987.619995	90-94	Women
51	1988-02-15	Jane Jones	83	Own home	Unlawful killing	1988	False	1987.619995	80-84	Women
52	1988-02-16	Lavinia Robinson	84	Own home	Unlawful killing	1988	False	1987.630005	80-84	Women
53	1988-09-18	Rose Ann Adshead	80	Own home	Unlawful killing	1988	False	1988.219971	80-84	Women
54	1988-10-20	Alice Prestwich	69	Own home	Unlawful killing	1988	False	1988.300049	65-69	Women
55	1988-11-06	Walter Tingle	85	Own home	Unlawful killing	1988	True	1988.349976	85-89	Men
56	1988-12-17	Harry Stafford	87	Own home	Unlawful killing	1988	True	1988.459961	85-89	Men
57	1988-12-19	Ethel Bennett	80	Own home	Unlawful killing	1988	False	1988.469971	80-84	Women
58	1989-01-31	Wilfred Chappell	80	Own home	Unlawful killing	1989	False	1988.589966	80-84	Women
59	1989-03-08	Mary Emma Hamer	81	Shipman's surgery	Unlawful killing	1989	False	1988.680054	80-84	Women
60	1989-05-12	Beatrice Helen Clee	78	Own home	Unlawful killing	1989	False	1988.859985	75-79	Women
61	1989-06-05	Josephine Hall	69	Own home	Unlawful killing	1989	False	1988.930054	65-69	Women
62	1989-07-06	Hilda Fitton	75	Own home	Unlawful killing	1989	False	1989.010010	75-79	Women
63	1989-08-14	Marion Carradice	80	Own home	Unlawful killing	1989	False	1989.119995	80-84	Women
64	1989-09-22	Elsie Harrop	82	Own home	Unlawful killing	1989	False	1989.229980	80-84	Women
65	1989-09-26	Elizabeth Mary Burke	82	Own home	Unlawful killing	1989	False	1989.239990	80-84	Women
66	1989-10-15	Sarah Jane Williamson	82	Own home	Unlawful killing	1989	False	1989.290039	80-84	Women
67	1989-10-16	John Charlton	81	Own home	Unlawful killing	1989	True	1989.290039	80-84	Men
68	1989-10-18	George Edgar Vizor	67	Own home	Unlawful killing	1989	True	1989.300049	65-69	Men
69	1989-11-06	Joseph Frank Wilcockson	85	Own home	Unlawful killing	1989	True	1989.349976	85-89	Men
70	1990-09-18	Dorothy Rowarth	56	Own home	Unlawful killing	1990	False	1990.219971	55-59	Women
71	1990-12-30	Mary Rose Dudley	69	Own home	Unlawful killing	1990	False	1990.500000	65-69	Women
72	1992-10-07	Monica Rene Sparkes	72	Own home	Unlawful killing	1992	False	1992.270020	70-74	Women
73	1993-02-24	Olive Heginbotham	86	Own home	Unlawful killing	1993	False	1992.650024	85-89	Women
74	1993-02-24	Hilda Mary Couzens	92	Own home	Unlawful killing	1993	False	1992.650024	90-94	Women
75	1993-03-22	Amy Whitehead	82	Own home	Unlawful killing	1993	False	1992.719971	80-84	Women
76	1993-04-08	Mary Emma Andrew	86	Own home	Unlawful killing	1993	False	1992.770020	85-89	Women
77	1993-04-17	Sarah Ashworth	74	Own home	Unlawful killing	1993	False	1992.790039	70-74	Women
78	1993-04-26	Fanny Nichols	84	Own home	Unlawful killing	1993	False	1992.819946	80-84	Women
79	1993-04-27	Marjorie Parker	74	Own home	Unlawful killing	1993	False	1992.819946	70-74	Women
80	1993-05-02	Nellie Mullen	77	Own home	Unlawful killing	1993	False	1992.839966	75-79	Women
81	1993-05-04	Edna May Llewellyn	68	Own home	Unlawful killing	1993	False	1992.839966	65-69	Women
82	1993-05-12	Emily Morgan	84	Own home	Unlawful killing	1993	False	1992.859985	80-84	Women
83	1993-05-13	Violet May Bird	60	Own home	Unlawful killing	1993	False	1992.869995	60-64	Women
84	1993-07-22	Jose Kathleen Diana Richards	74	Own home	Unlawful killing	1993	False	1993.060059	70-74	Women
85	1993-08-16	Edith Calverley	77	Own home	Unlawful killing	1993	False	1993.130005	75-79	Women
86	1993-12-16	Joseph Leigh	78	Own home	Unlawful killing	1993	False	1993.459961	75-79	Women
87	1993-12-22	Eileen Robinson	54	Own home	Unlawful killing	1993	False	1993.479980	50-54	Women
88	1993-12-31	Charles Edward Brocklehurst	90	Own home	Unlawful killing	1993	True	1993.500000	90-94	Men
89	1994-01-04	Joan Milray Harding	82	Shipman's surgery	Unlawful killing	1994	False	1993.510010	80-84	Women
90	1994-01-13	Christine Hancock	53	Own home	Unlawful killing	1994	False	1993.540039	50-54	Women
91	1994-02-09	Elsie Platt	73	Own home	Unlawful killing	1994	False	1993.609985	70-74	Women
92	1994-05-17	Mary Alice Smith	84	Own home	Unlawful killing	1994	False	1993.880005	80-84	Women
93	1994-05-25	Ronnie Devenport	57	Own home	Unlawful killing	1994	False	1993.900024	55-59	Women
94	1994-06-15	Cicely Sharples	87	Own home	Unlawful killing	1994	False	1993.959961	85-89	Women
95	1994-06-17	Alice Christine Kitchen	70	Own home	Unlawful killing	1994	False	1993.959961	70-74	Women
96	1994-07-27	Maria Thornton	78	Own home	Unlawful killing	1994	False	1994.069946	75-79	Women
97	1994-11-25	Henrietta Walker	87	Own home	Unlawful killing	1994	False	1994.400024	85-89	Women
98	1994-11-30	Elizabeth Ellen Mellor	75	Own home	Unlawful killing	1994	False	1994.420044	75-79	Women
99	1994-12-29	John Bennett Molesdale	81	Own home	Unlawful killing	1994	False	1994.500000	80-84	Women
100	1995-01-09	Alice Kennedy	88	Own home	Unlawful killing	1995	False	1994.530029	85-89	Women
101	1995-03-01	Lucy Virgin	70	Own home	Unlawful killing	1995	False	1994.670044	70-74	Women
102	1995-03-03	Joseph Shaw	88	Own home	Unlawful killing	1995	True	1994.670044	85-89	Men
103	1995-03-06	Maria West	81	Own home	Conviction	1995	False	1994.680054	80-84	Women
104	1995-03-07	Netta Ashcroft	71	Own home	Unlawful killing	1995	False	1994.680054	70-74	Women
105	1995-03-07	Lily Bardsley	88	Own home	Unlawful killing	1995	False	1994.680054	85-89	Women
106	1995-03-13	Marie Antoinette Fernley	53	Own home	Unlawful killing	1995	False	1994.699951	50-54	Women
107	1995-03-21	John Crompton	82	Own home	Unlawful killing	1995	True	1994.719971	80-84	Men
108	1995-03-26	Frank Crompton	86	Own home	Unlawful killing	1995	True	1994.729980	85-89	Men
109	1995-03-31	Vera Brocklehurst	70	Own home	Unlawful killing	1995	False	1994.750000	70-74	Women
110	1995-04-10	Angela Philomena Tierney	71	Own home	Unlawful killing	1995	False	1994.780029	70-74	Women
111	1995-04-13	Edith Scott	85	Own home	Unlawful killing	1995	False	1994.780029	85-89	Women
112	1995-04-14	Clara Hackney	84	Own home	Unlawful killing	1995	False	1994.790039	80-84	Women
113	1995-04-21	Renate Eldtraude Overton	47	Hospital	Unlawful killing	1995	False	1994.810059	45-49	Women
114	1995-05-04	Kate Maud Sellors	75	Own home	Unlawful killing	1995	False	1994.839966	75-79	Women
115	1995-06-02	Clifford Barnes Heapey	85	Nursing home	Unlawful killing	1995	True	1994.920044	85-89	Men
116	1995-06-13	Bertha Moss	68	Shipman's surgery	Unlawful killing	1995	False	1994.949951	65-69	Women
117	1995-06-17	Brenda Ashworth	63	Own home	Unlawful killing	1995	False	1994.959961	60-64	Women
118	1995-06-29	Ernest Rudol	82	Own home	Unlawful killing	1995	False	1994.989990	80-84	Women
119	1995-07-12	Ada Matley Hilton	88	Own home	Unlawful killing	1995	False	1995.030029	85-89	Women
120	1995-07-31	Irene Aitken	65	Own home	Unlawful killing	1995	False	1995.079956	65-69	Women
121	1995-08-29	Arthur Henderson Stopford	82	Own home	Unlawful killing	1995	True	1995.160034	80-84	Men
122	1995-09-14	Geoffrey Bogle	72	Own home	Unlawful killing	1995	True	1995.209961	70-74	Men
123	1995-09-26	Dora Elizabeth Ashton	87	Shipman's surgery	Unlawful killing	1995	False	1995.239990	85-89	Women
124	1995-10-24	Muriel Margaret Ward	87	Own home	Unlawful killing	1995	False	1995.319946	85-89	Women
125	1995-11-08	Edith Brock	74	Own home	Unlawful killing	1995	False	1995.359985	70-74	Women
126	1995-11-22	Charles Henry Barlow	88	Own home	Unlawful killing	1995	True	1995.390015	85-89	Men
127	1995-11-25	Konrad Peter Ovcar-Robinson	43	Own home	Unlawful killing	1995	True	1995.400024	40-44	Men
128	1995-12-14	Elizabeth Teresa Sigley	67	Own home	Unlawful killing	1995	False	1995.449951	65-69	Women
129	1995-12-14	Kenneth Wharmby Woodhead	75	Own home	Unlawful killing	1995	True	1995.449951	75-79	Men
130	1996-01-02	Hilda Mary Hibbert	81	Own home	Unlawful killing	1996	False	1995.500000	80-84	Women
131	1996-01-11	Erla Copeland	79	Own home	Unlawful killing	1996	False	1995.530029	75-79	Women
132	1996-02-21	Jane Elizabeth Shelmerdine	80	Own home	Unlawful killing	1996	False	1995.640015	80-84	Women
133	1996-02-27	John Sheard Greenhalgh	88	Own home	Unlawful killing	1996	True	1995.660034	85-89	Men
134	1996-03-12	Minnie Doris Irene Galpin	71	Own home	Unlawful killing	1996	False	1995.699951	70-74	Women
135	1996-04-18	Marjorie Hope Waller	79	Own home	Unlawful killing	1996	False	1995.800049	75-79	Women
136	1996-04-24	John Stone	77	Own home	Unlawful killing	1996	True	1995.810059	75-79	Men
137	1996-05-07	Elsie Godfrey	85	Own home	Unlawful killing	1996	False	1995.849976	85-89	Women
138	1996-05-13	Edith Brady	72	Shipman's surgery	Unlawful killing	1996	False	1995.869995	70-74	Women
139	1996-05-29	Valerie Cuthbert	54	Own home	Unlawful killing	1996	False	1995.910034	50-54	Women
140	1996-05-30	Lilian Cullen	77	Own home	Unlawful killing	1996	False	1995.910034	75-79	Women
141	1996-06-06	Renee Lacey	63	Own home	Unlawful killing	1996	False	1995.930054	60-64	Women
142	1996-06-10	Leah Fogg	82	Own home	Unlawful killing	1996	False	1995.939941	80-84	Women
143	1996-06-17	Gladys Saunders	82	Own home	Unlawful killing	1996	False	1995.959961	80-84	Women
144	1996-06-25	Nellie Bennett	86	Own home	Unlawful killing	1996	False	1995.979980	85-89	Women
145	1996-06-25	Margaret Mary Vickers	81	Own home	Unlawful killing	1996	False	1995.979980	80-84	Women
146	1996-07-02	Tom Balfour Russell	77	Own home	Unlawful killing	1996	True	1996.000000	75-79	Men
147	1996-07-11	Irene Turner	67	Own home	Conviction	1996	False	1996.030029	65-69	Women
148	1996-07-16	Carrie Leigh	81	Own home	Unlawful killing	1996	False	1996.040039	80-84	Women
149	1996-07-19	Marion Elizabeth Higham	84	Own home	Unlawful killing	1996	False	1996.050049	80-84	Women
150	1996-07-24	Elsie Hannible	85	Own home	Unlawful killing	1996	False	1996.060059	85-89	Women
151	1996-07-29	Elsie Barker	84	Own home	Unlawful killing	1996	False	1996.079956	80-84	Women
152	1996-08-30	Sidney Arthur Smith	76	Own home	Unlawful killing	1996	True	1996.160034	75-79	Men
153	1996-09-12	Dorothy Mary Andrew	85	Own home	Unlawful killing	1996	False	1996.199951	85-89	Women
154	1996-09-20	Anne Lilian Ralphs	75	Own home	Unlawful killing	1996	False	1996.219971	75-79	Women
155	1996-10-23	Millicent Garside	76	Own home	Unlawful killing	1996	False	1996.310059	75-79	Women
156	1996-11-20	Irene Heathcote	76	Own home	Unlawful killing	1996	False	1996.390015	75-79	Women
157	1996-11-23	Samuel Mills	89	Own home	Unlawful killing	1996	False	1996.400024	85-89	Women
158	1996-12-04	Thomas Cheetham	78	Own home	Unlawful killing	1996	True	1996.430054	75-79	Men
159	1996-12-17	Kenneth Ernest Smith	73	Own home	Unlawful killing	1996	True	1996.459961	70-74	Men
160	1997-01-02	Eileen Daphne Crompton	75	Residential home	Unlawful killing	1997	False	1996.510010	75-79	Women
161	1997-01-03	David Alan Harrison	47	Own home	Unlawful killing	1997	True	1996.510010	45-49	Men
162	1997-01-08	Elsie Lorna Dean	69	Own home	Unlawful killing	1997	False	1996.520020	65-69	Women
163	1997-01-20	Irene Brooder	76	Own home	Unlawful killing	1997	False	1996.560059	75-79	Women
164	1997-01-27	Charlotte Bennison	89	Own home	Unlawful killing	1997	False	1996.579956	85-89	Women
165	1997-02-03	Charles Henry Killan	90	Own home	Unlawful killing	1997	False	1996.589966	90-94	Women
166	1997-02-04	Betty Royston	70	Own home	Unlawful killing	1997	False	1996.599976	70-74	Women
167	1997-02-23	Joyce Woodhead	74	Own home	Unlawful killing	1997	False	1996.650024	70-74	Women
168	1997-02-28	Lizzie Adams	77	Own home	Conviction	1997	False	1996.660034	75-79	Women
169	1997-03-22	Rose Garlick	76	Own home	Unlawful killing	1997	False	1996.719971	75-79	Women
170	1997-03-27	May Lowe	84	Own home	Unlawful killing	1997	False	1996.739990	80-84	Women
171	1997-04-21	Mary Coutts	80	Own home	Unlawful killing	1997	False	1996.810059	80-84	Women
172	1997-04-25	Elsie Cheetham	76	Own home	Unlawful killing	1997	False	1996.819946	75-79	Women
173	1997-04-25	Jean Lilley	58	Own home	Conviction	1997	False	1996.819946	55-59	Women
174	1997-05-02	Lena Norah Slater	68	Own home	Unlawful killing	1997	False	1996.839966	65-69	Women
175	1997-05-12	Ethel May Kellett	74	Own home	Unlawful killing	1997	False	1996.859985	70-74	Women
176	1997-05-21	Doris Earls	79	Own home	Unlawful killing	1997	False	1996.890015	75-79	Women
177	1997-05-29	Ivy Lomas	63	Shipman's surgery	Conviction	1997	False	1996.910034	60-64	Women
178	1997-06-24	Vera Whittingslow	69	Own home	Unlawful killing	1997	False	1996.979980	65-69	Women
179	1997-07-07	Maureen Lamonnier Jackson	51	Own home	Unlawful killing	1997	False	1997.020020	50-54	Women
180	1997-07-14	Muriel Grimshaw	76	Own home	Conviction	1997	False	1997.040039	75-79	Women
181	1997-07-25	John Louden Livesey	69	Own home	Unlawful killing	1997	True	1997.069946	65-69	Men
182	1997-07-28	Lily Newby Taylor	86	Own home	Unlawful killing	1997	False	1997.069946	85-89	Women
183	1997-08-10	Dorothy Doretta Hopkins	72	Own home	Unlawful killing	1997	False	1997.109985	70-74	Women
184	1997-09-01	Nancy Jackson	81	Own home	Unlawful killing	1997	False	1997.170044	80-84	Women
185	1997-09-22	Mavis Mary Pickup	79	Own home	Unlawful killing	1997	False	1997.229980	75-79	Women
186	1997-09-26	Bessie Swann	79	Own home	Unlawful killing	1997	False	1997.239990	75-79	Women
187	1997-09-29	Enid Otter	77	Own home	Unlawful killing	1997	False	1997.250000	75-79	Women
188	1997-11-10	Florence Lewis	79	Own home	Unlawful killing	1997	False	1997.359985	75-79	Women
189	1997-11-14	Mary Walls	78	Own home	Unlawful killing	1997	False	1997.369995	75-79	Women
190	1997-11-21	Elizabeth Mary Baddeley	83	Own home	Unlawful killing	1997	False	1997.390015	80-84	Women
191	1997-11-24	Marie Quinn	67	Own home	Conviction	1997	False	1997.400024	65-69	Women
192	1997-12-08	Elizabeth Battersby	70	Own home	Unlawful killing	1997	False	1997.439941	70-74	Women
193	1997-12-09	Laura Kathleen Wagstaff	81	Own home	Conviction	1997	False	1997.439941	80-84	Women
194	1997-12-10	Bianka Pomfret	49	Own home	Conviction	1997	False	1997.439941	45-49	Women
195	1997-12-18	Alice Black	73	Own home	Unlawful killing	1997	False	1997.469971	70-74	Women
196	1997-12-24	James Joseph King	83	Own home	Unlawful killing	1997	True	1997.479980	80-84	Men
197	1998-01-22	Mabel Shawcross	79	Own home	Unlawful killing	1998	False	1997.560059	75-79	Women
198	1998-01-26	Norah Nuttall	64	Own home	Conviction	1998	False	1997.569946	60-64	Women
199	1998-02-02	Cissie Davies	73	Own home	Unlawful killing	1998	False	1997.589966	70-74	Women
200	1998-02-09	Pamela Marguerite Hillier	68	Own home	Conviction	1998	False	1997.609985	65-69	Women
201	1998-02-13	Laura Frances Linn	83	Own home	Unlawful killing	1998	False	1997.619995	80-84	Women
202	1998-02-15	Irene Berry	74	Own home	Unlawful killing	1998	False	1997.630005	70-74	Women
203	1998-02-18	Maureen Alice Ward	57	Own home	Conviction	1998	False	1997.640015	55-59	Women
204	1998-02-27	Joan Edwina Dean	75	Own home	Unlawful killing	1998	False	1997.660034	75-79	Women
205	1998-03-04	Harold Eddleston	77	Own home	Unlawful killing	1998	True	1997.670044	75-79	Men
206	1998-03-06	Margaret Anne Waldron	65	Own home	Unlawful killing	1998	False	1997.680054	65-69	Women
207	1998-03-07	Irene Chapman	74	Own home	Unlawful killing	1998	False	1997.680054	70-74	Women
208	1998-03-13	Dorothy Long	84	Own home	Unlawful killing	1998	False	1997.699951	80-84	Women
209	1998-03-17	Lily Higgins	83	Own home	Unlawful killing	1998	False	1997.709961	80-84	Women
210	1998-03-20	Ada Warburton	77	Own home	Unlawful killing	1998	False	1997.719971	75-79	Women
211	1998-03-24	Martha Marley	88	Own home	Unlawful killing	1998	False	1997.729980	85-89	Women
212	1998-05-11	Winifred Mellor	73	Own home	Conviction	1998	False	1997.859985	70-74	Women
213	1998-06-12	Joan May Melia	73	Own home	Conviction	1998	False	1997.949951	70-74	Women
214	1998-06-24	Kathleen Grundy	81	Own home	Conviction	1998	False	1997.979980	80-84	Women